<?xml version="1.0" encoding="UTF-8"?>
<!--

CREATE TABLE my_tt_agg_small (
    symbol character(16),
    event_ts bigint,
    trade_price numeric,
    trade_volume bigint
) DISTRIBUTED BY (symbol);


CREATE TABLE my_tq_agg_small (
    ets bigint,
    sym character varying(16),
    bid_price numeric,
    ask_price numeric,
    end_ts bigint
) DISTRIBUTED BY (ets)
  PARTITION BY RANGE(bid_price)(PARTITION p1 START(1) END(200000),
                                PARTITION p2 START(200000) END(400000),
                                PARTITION p3 START(400000) END(900000));

CREATE INDEX my_tq_agg_small_ets_end_ts_ix ON my_tq_agg_small USING btree (ets, end_ts);

analyze my_tq_agg_small;
analyze my_tt_agg_small;

set optimizer=on;
set optimizer_enable_indexjoin=on;
select disable_xform('CXformInnerJoin2HashJoin');
select disable_xform('CXformInnerJoin2IndexGetApply');
select disable_xform('CXformInnerJoin2NLJoin');

set optimizer_minidump = 'always';
set optimizer_cost_model='legacy';

EXPLAIN
SELECT (tt.event_ts / 100000) / 5 * 5 as fivemin
FROM my_tt_agg_small tt, my_tq_agg_small tq
WHERE tq.sym = tt.symbol AND
      tt.event_ts >= tq.ets AND
      tt.event_ts <  tq.end_ts
GROUP BY 1
ORDER BY 1 asc ;

-->
<dxl:DXLMessage xmlns:dxl="http://greenplum.com/dxl/2010/12/">
  <dxl:Thread Id="0">
    <dxl:OptimizerConfig>
      <dxl:EnumeratorConfig Id="0" PlanSamples="0" CostThreshold="0"/>
      <dxl:StatisticsConfig DampingFactorFilter="0.750000" DampingFactorJoin="0.000000" DampingFactorGroupBy="0.750000" MaxStatsBuckets="100"/>
      <dxl:CTEConfig CTEInliningCutoff="0"/> 
      <dxl:WindowOids RowNumber="7000" Rank="7001"/>
      <dxl:TraceFlags Value="102001,102002,102003,102024,102027,102029,102115,102116,102117,102119,102144,103027,103033"/>
    </dxl:OptimizerConfig>
    <dxl:Metadata SystemIds="0.GPDB">
      <dxl:Relation Mdid="6.16166659.1.0" Name="my_tq_agg_small" IsTemporary="false" HasOids="false" StorageType="Heap" DistributionPolicy="Hash" DistributionColumns="0" Keys="10,11,5" PartitionColumns="2" PartitionTypes="r">
        <dxl:Columns>
          <dxl:Column Name="ets" Attno="1" Mdid="0.20.1.0" Nullable="true" ColWidth="8">
            <dxl:DefaultValue/>
          </dxl:Column>
          <dxl:Column Name="sym" Attno="2" Mdid="0.1043.1.0" Nullable="true" ColWidth="16">
            <dxl:DefaultValue/>
          </dxl:Column>
          <dxl:Column Name="bid_price" Attno="3" Mdid="0.1700.1.0" Nullable="true" ColWidth="8">
            <dxl:DefaultValue/>
          </dxl:Column>
          <dxl:Column Name="ask_price" Attno="4" Mdid="0.1700.1.0" Nullable="true" ColWidth="8">
            <dxl:DefaultValue/>
          </dxl:Column>
          <dxl:Column Name="end_ts" Attno="5" Mdid="0.20.1.0" Nullable="true" ColWidth="8">
            <dxl:DefaultValue/>
          </dxl:Column>
          <dxl:Column Name="ctid" Attno="-1" Mdid="0.27.1.0" Nullable="false" ColWidth="6">
            <dxl:DefaultValue/>
          </dxl:Column>
          <dxl:Column Name="xmin" Attno="-3" Mdid="0.28.1.0" Nullable="false" ColWidth="4">
            <dxl:DefaultValue/>
          </dxl:Column>
          <dxl:Column Name="cmin" Attno="-4" Mdid="0.29.1.0" Nullable="false" ColWidth="4">
            <dxl:DefaultValue/>
          </dxl:Column>
          <dxl:Column Name="xmax" Attno="-5" Mdid="0.28.1.0" Nullable="false" ColWidth="4">
            <dxl:DefaultValue/>
          </dxl:Column>
          <dxl:Column Name="cmax" Attno="-6" Mdid="0.29.1.0" Nullable="false" ColWidth="4">
            <dxl:DefaultValue/>
          </dxl:Column>
          <dxl:Column Name="tableoid" Attno="-7" Mdid="0.26.1.0" Nullable="false" ColWidth="4">
            <dxl:DefaultValue/>
          </dxl:Column>
          <dxl:Column Name="gp_segment_id" Attno="-8" Mdid="0.23.1.0" Nullable="false" ColWidth="4">
            <dxl:DefaultValue/>
          </dxl:Column>
        </dxl:Columns>
        <dxl:IndexInfoList>
          <dxl:IndexInfo Mdid="0.16166830.1.0" IsPartial="false"/>
        </dxl:IndexInfoList>
        <dxl:Triggers/>
        <dxl:CheckConstraints/>
        <dxl:PartConstraint DefaultPartition="" Unbounded="false">
          <dxl:And>
            <dxl:Comparison ComparisonOperator="&gt;=" OperatorMdid="0.1757.1.0">
              <dxl:Ident ColId="3" ColName="bid_price" TypeMdid="0.1700.1.0"/>
              <dxl:ConstValue TypeMdid="0.1700.1.0" Value="AAAACgAAAAABAA==" DoubleValue="1.000000"/>
            </dxl:Comparison>
            <dxl:Comparison ComparisonOperator="&lt;" OperatorMdid="0.1754.1.0">
              <dxl:Ident ColId="3" ColName="bid_price" TypeMdid="0.1700.1.0"/>
              <dxl:ConstValue TypeMdid="0.1700.1.0" Value="AAAACgEAAABaAA==" DoubleValue="900000.000000"/>
            </dxl:Comparison>
          </dxl:And>
        </dxl:PartConstraint>
      </dxl:Relation>
      <dxl:RelationStatistics Mdid="2.16166659.1.1" Name="my_tq_agg_small" Rows="0.000000" EmptyRelation="true"/>
      <dxl:Relation Mdid="6.16166659.1.1" Name="my_tq_agg_small" IsTemporary="false" HasOids="false" StorageType="Heap" DistributionPolicy="Hash" DistributionColumns="0" Keys="10,11,5" PartitionColumns="2" PartitionTypes="r">
        <dxl:Columns>
          <dxl:Column Name="ets" Attno="1" Mdid="0.20.1.0" Nullable="true" ColWidth="8">
            <dxl:DefaultValue/>
          </dxl:Column>
          <dxl:Column Name="sym" Attno="2" Mdid="0.1043.1.0" Nullable="true" ColWidth="16">
            <dxl:DefaultValue/>
          </dxl:Column>
          <dxl:Column Name="bid_price" Attno="3" Mdid="0.1700.1.0" Nullable="true" ColWidth="8">
            <dxl:DefaultValue/>
          </dxl:Column>
          <dxl:Column Name="ask_price" Attno="4" Mdid="0.1700.1.0" Nullable="true" ColWidth="8">
            <dxl:DefaultValue/>
          </dxl:Column>
          <dxl:Column Name="end_ts" Attno="5" Mdid="0.20.1.0" Nullable="true" ColWidth="8">
            <dxl:DefaultValue/>
          </dxl:Column>
          <dxl:Column Name="ctid" Attno="-1" Mdid="0.27.1.0" Nullable="false" ColWidth="6">
            <dxl:DefaultValue/>
          </dxl:Column>
          <dxl:Column Name="xmin" Attno="-3" Mdid="0.28.1.0" Nullable="false" ColWidth="4">
            <dxl:DefaultValue/>
          </dxl:Column>
          <dxl:Column Name="cmin" Attno="-4" Mdid="0.29.1.0" Nullable="false" ColWidth="4">
            <dxl:DefaultValue/>
          </dxl:Column>
          <dxl:Column Name="xmax" Attno="-5" Mdid="0.28.1.0" Nullable="false" ColWidth="4">
            <dxl:DefaultValue/>
          </dxl:Column>
          <dxl:Column Name="cmax" Attno="-6" Mdid="0.29.1.0" Nullable="false" ColWidth="4">
            <dxl:DefaultValue/>
          </dxl:Column>
          <dxl:Column Name="tableoid" Attno="-7" Mdid="0.26.1.0" Nullable="false" ColWidth="4">
            <dxl:DefaultValue/>
          </dxl:Column>
          <dxl:Column Name="gp_segment_id" Attno="-8" Mdid="0.23.1.0" Nullable="false" ColWidth="4">
            <dxl:DefaultValue/>
          </dxl:Column>
        </dxl:Columns>
        <dxl:IndexInfoList>
          <dxl:IndexInfo Mdid="0.16166830.1.0" IsPartial="false"/>
        </dxl:IndexInfoList>
        <dxl:Triggers/>
        <dxl:CheckConstraints/>
        <dxl:PartConstraint DefaultPartition="" Unbounded="false">
          <dxl:And>
            <dxl:Comparison ComparisonOperator="&gt;=" OperatorMdid="0.1757.1.0">
              <dxl:Ident ColId="3" ColName="bid_price" TypeMdid="0.1700.1.0"/>
              <dxl:ConstValue TypeMdid="0.1700.1.0" Value="AAAACgAAAAABAA==" DoubleValue="1.000000"/>
            </dxl:Comparison>
            <dxl:Comparison ComparisonOperator="&lt;" OperatorMdid="0.1754.1.0">
              <dxl:Ident ColId="3" ColName="bid_price" TypeMdid="0.1700.1.0"/>
              <dxl:ConstValue TypeMdid="0.1700.1.0" Value="AAAACgEAAABaAA==" DoubleValue="900000.000000"/>
            </dxl:Comparison>
          </dxl:And>
        </dxl:PartConstraint>
      </dxl:Relation>
      <dxl:Type Mdid="0.16.1.0" Name="bool" IsRedistributable="true" IsHashable="true" IsMergeJoinable="true" IsComposite="false" IsFixedLength="true" Length="1" PassByValue="true">
        <dxl:EqualityOp Mdid="0.91.1.0"/>
        <dxl:InequalityOp Mdid="0.85.1.0"/>
        <dxl:LessThanOp Mdid="0.58.1.0"/>
        <dxl:LessThanEqualsOp Mdid="0.1694.1.0"/>
        <dxl:GreaterThanOp Mdid="0.59.1.0"/>
        <dxl:GreaterThanEqualsOp Mdid="0.1695.1.0"/>
        <dxl:ComparisonOp Mdid="0.1693.1.0"/>
        <dxl:ArrayType Mdid="0.1000.1.0"/>
        <dxl:MinAgg Mdid="0.0.0.0"/>
        <dxl:MaxAgg Mdid="0.0.0.0"/>
        <dxl:AvgAgg Mdid="0.0.0.0"/>
        <dxl:SumAgg Mdid="0.0.0.0"/>
        <dxl:CountAgg Mdid="0.2147.1.0"/>
      </dxl:Type>
      <dxl:Type Mdid="0.1043.1.0" Name="varchar" IsRedistributable="true" IsHashable="true" IsMergeJoinable="true" IsComposite="false" IsTextRelated="true" IsFixedLength="false" Length="-1" PassByValue="false">
        <dxl:EqualityOp Mdid="0.98.1.0"/>
        <dxl:InequalityOp Mdid="0.531.1.0"/>
        <dxl:LessThanOp Mdid="0.664.1.0"/>
        <dxl:LessThanEqualsOp Mdid="0.665.1.0"/>
        <dxl:GreaterThanOp Mdid="0.666.1.0"/>
        <dxl:GreaterThanEqualsOp Mdid="0.667.1.0"/>
        <dxl:ComparisonOp Mdid="0.360.1.0"/>
        <dxl:ArrayType Mdid="0.1015.1.0"/>
        <dxl:MinAgg Mdid="0.0.0.0"/>
        <dxl:MaxAgg Mdid="0.0.0.0"/>
        <dxl:AvgAgg Mdid="0.0.0.0"/>
        <dxl:SumAgg Mdid="0.0.0.0"/>
        <dxl:CountAgg Mdid="0.2147.1.0"/>
      </dxl:Type>
      <dxl:Type Mdid="0.1042.1.0" Name="bpchar" IsRedistributable="true" IsHashable="true" IsMergeJoinable="true" IsComposite="false" IsTextRelated="true" IsFixedLength="false" Length="-1" PassByValue="false">
        <dxl:EqualityOp Mdid="0.1054.1.0"/>
        <dxl:InequalityOp Mdid="0.1057.1.0"/>
        <dxl:LessThanOp Mdid="0.1058.1.0"/>
        <dxl:LessThanEqualsOp Mdid="0.1059.1.0"/>
        <dxl:GreaterThanOp Mdid="0.1060.1.0"/>
        <dxl:GreaterThanEqualsOp Mdid="0.1061.1.0"/>
        <dxl:ComparisonOp Mdid="0.1078.1.0"/>
        <dxl:ArrayType Mdid="0.1014.1.0"/>
        <dxl:MinAgg Mdid="0.2245.1.0"/>
        <dxl:MaxAgg Mdid="0.2244.1.0"/>
        <dxl:AvgAgg Mdid="0.0.0.0"/>
        <dxl:SumAgg Mdid="0.0.0.0"/>
        <dxl:CountAgg Mdid="0.2147.1.0"/>
      </dxl:Type>
      <dxl:Type Mdid="0.20.1.0" Name="Int8" IsRedistributable="true" IsHashable="true" IsMergeJoinable="true" IsComposite="false" IsFixedLength="true" Length="8" PassByValue="true">
        <dxl:EqualityOp Mdid="0.410.1.0"/>
        <dxl:InequalityOp Mdid="0.411.1.0"/>
        <dxl:LessThanOp Mdid="0.412.1.0"/>
        <dxl:LessThanEqualsOp Mdid="0.414.1.0"/>
        <dxl:GreaterThanOp Mdid="0.413.1.0"/>
        <dxl:GreaterThanEqualsOp Mdid="0.415.1.0"/>
        <dxl:ComparisonOp Mdid="0.351.1.0"/>
        <dxl:ArrayType Mdid="0.1016.1.0"/>
        <dxl:MinAgg Mdid="0.2131.1.0"/>
        <dxl:MaxAgg Mdid="0.2115.1.0"/>
        <dxl:AvgAgg Mdid="0.2100.1.0"/>
        <dxl:SumAgg Mdid="0.2107.1.0"/>
        <dxl:CountAgg Mdid="0.2147.1.0"/>
      </dxl:Type>
      <dxl:Type Mdid="0.23.1.0" Name="int4" IsRedistributable="true" IsHashable="true" IsMergeJoinable="true" IsComposite="false" IsFixedLength="true" Length="4" PassByValue="true">
        <dxl:EqualityOp Mdid="0.96.1.0"/>
        <dxl:InequalityOp Mdid="0.518.1.0"/>
        <dxl:LessThanOp Mdid="0.97.1.0"/>
        <dxl:LessThanEqualsOp Mdid="0.523.1.0"/>
        <dxl:GreaterThanOp Mdid="0.521.1.0"/>
        <dxl:GreaterThanEqualsOp Mdid="0.525.1.0"/>
        <dxl:ComparisonOp Mdid="0.351.1.0"/>
        <dxl:ArrayType Mdid="0.1007.1.0"/>
        <dxl:MinAgg Mdid="0.2132.1.0"/>
        <dxl:MaxAgg Mdid="0.2116.1.0"/>
        <dxl:AvgAgg Mdid="0.2101.1.0"/>
        <dxl:SumAgg Mdid="0.2108.1.0"/>
        <dxl:CountAgg Mdid="0.2147.1.0"/>
      </dxl:Type>
      <dxl:Type Mdid="0.26.1.0" Name="oid" IsRedistributable="true" IsHashable="true" IsMergeJoinable="true" IsComposite="false" IsFixedLength="true" Length="4" PassByValue="true">
        <dxl:EqualityOp Mdid="0.607.1.0"/>
        <dxl:InequalityOp Mdid="0.608.1.0"/>
        <dxl:LessThanOp Mdid="0.609.1.0"/>
        <dxl:LessThanEqualsOp Mdid="0.611.1.0"/>
        <dxl:GreaterThanOp Mdid="0.610.1.0"/>
        <dxl:GreaterThanEqualsOp Mdid="0.612.1.0"/>
        <dxl:ComparisonOp Mdid="0.356.1.0"/>
        <dxl:ArrayType Mdid="0.1028.1.0"/>
        <dxl:MinAgg Mdid="0.2118.1.0"/>
        <dxl:MaxAgg Mdid="0.2134.1.0"/>
        <dxl:AvgAgg Mdid="0.0.0.0"/>
        <dxl:SumAgg Mdid="0.0.0.0"/>
        <dxl:CountAgg Mdid="0.2147.1.0"/>
      </dxl:Type>
      <dxl:Type Mdid="0.27.1.0" Name="tid" IsRedistributable="true" IsHashable="false" IsMergeJoinable="false" IsComposite="false" IsFixedLength="true" Length="6" PassByValue="false">
        <dxl:EqualityOp Mdid="0.387.1.0"/>
        <dxl:InequalityOp Mdid="0.402.1.0"/>
        <dxl:LessThanOp Mdid="0.2799.1.0"/>
        <dxl:LessThanEqualsOp Mdid="0.2801.1.0"/>
        <dxl:GreaterThanOp Mdid="0.2800.1.0"/>
        <dxl:GreaterThanEqualsOp Mdid="0.2802.1.0"/>
        <dxl:ComparisonOp Mdid="0.2794.1.0"/>
        <dxl:ArrayType Mdid="0.1010.1.0"/>
        <dxl:MinAgg Mdid="0.2798.1.0"/>
        <dxl:MaxAgg Mdid="0.2797.1.0"/>
        <dxl:AvgAgg Mdid="0.0.0.0"/>
        <dxl:SumAgg Mdid="0.0.0.0"/>
        <dxl:CountAgg Mdid="0.2147.1.0"/>
      </dxl:Type>
      <dxl:GPDBScalarOp Mdid="0.413.1.0" Name="&gt;" ComparisonType="GT" ReturnsNullOnNullInput="true">
        <dxl:LeftType Mdid="0.20.1.0"/>
        <dxl:RightType Mdid="0.20.1.0"/>
        <dxl:ResultType Mdid="0.16.1.0"/>
        <dxl:OpFunc Mdid="0.470.1.0"/>
        <dxl:Commutator Mdid="0.412.1.0"/>
        <dxl:InverseOp Mdid="0.414.1.0"/>
        <dxl:Opfamilies>
          <dxl:Opfamily Mdid="0.1980.1.0"/>
          <dxl:Opfamily Mdid="0.3028.1.0"/>
        </dxl:Opfamilies>
      </dxl:GPDBScalarOp>
      <dxl:ColumnStatistics Mdid="1.16166659.1.1.11" Name="gp_segment_id" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000"/>
      <dxl:ColumnStatistics Mdid="1.16166659.1.1.10" Name="tableoid" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000"/>
      <dxl:ColumnStatistics Mdid="1.16166659.1.1.3" Name="ask_price" Width="8.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000"/>
      <dxl:ColumnStatistics Mdid="1.16166659.1.1.2" Name="bid_price" Width="8.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000"/>
      <dxl:ColumnStatistics Mdid="1.16166631.1.1.10" Name="gp_segment_id" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000"/>
      <dxl:ColumnStatistics Mdid="1.16166631.1.1.3" Name="trade_volume" Width="8.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000">
        <dxl:StatsBucket Frequency="0.514286" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="100"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.20.1.0" Value="100"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.002434" DistinctValues="0.511111">
          <dxl:LowerBound Closed="false" TypeMdid="0.20.1.0" Value="100"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="123"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.004762" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="123"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.20.1.0" Value="123"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.001270" DistinctValues="0.266667">
          <dxl:LowerBound Closed="false" TypeMdid="0.20.1.0" Value="123"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="135"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.002381" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="135"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.20.1.0" Value="135"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.000635" DistinctValues="0.133333">
          <dxl:LowerBound Closed="false" TypeMdid="0.20.1.0" Value="135"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="141"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.002381" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="141"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.20.1.0" Value="141"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.000423" DistinctValues="0.088889">
          <dxl:LowerBound Closed="false" TypeMdid="0.20.1.0" Value="141"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="145"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.004762" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="145"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.20.1.0" Value="145"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.001675" DistinctValues="1.099537">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="146"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="165"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.002381" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="165"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.20.1.0" Value="165"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.000529" DistinctValues="0.347222">
          <dxl:LowerBound Closed="false" TypeMdid="0.20.1.0" Value="165"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="171"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.002381" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="171"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.20.1.0" Value="171"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.002557" DistinctValues="1.678241">
          <dxl:LowerBound Closed="false" TypeMdid="0.20.1.0" Value="171"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="200"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.264286" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="200"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.20.1.0" Value="200"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.003333" DistinctValues="2.187500">
          <dxl:LowerBound Closed="false" TypeMdid="0.20.1.0" Value="200"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="270"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.004762" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="270"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.20.1.0" Value="270"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.001429" DistinctValues="0.937500">
          <dxl:LowerBound Closed="false" TypeMdid="0.20.1.0" Value="270"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="300"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.052381" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="300"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.20.1.0" Value="300"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.002421" DistinctValues="1.588983">
          <dxl:LowerBound Closed="false" TypeMdid="0.20.1.0" Value="300"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="330"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.002381" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="330"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.20.1.0" Value="330"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.002341" DistinctValues="1.536017">
          <dxl:LowerBound Closed="false" TypeMdid="0.20.1.0" Value="330"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="359"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.000810" DistinctValues="0.361515">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="359"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="400"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.009524" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="400"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.20.1.0" Value="400"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.000356" DistinctValues="0.158714">
          <dxl:LowerBound Closed="false" TypeMdid="0.20.1.0" Value="400"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="418"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.002381" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="418"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.20.1.0" Value="418"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.001620" DistinctValues="0.723029">
          <dxl:LowerBound Closed="false" TypeMdid="0.20.1.0" Value="418"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="500"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.016667" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="500"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.20.1.0" Value="500"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.001976" DistinctValues="0.881743">
          <dxl:LowerBound Closed="false" TypeMdid="0.20.1.0" Value="500"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="600"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.014286" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="600"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.20.1.0" Value="600"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.001190" DistinctValues="0.250000">
          <dxl:LowerBound Closed="false" TypeMdid="0.20.1.0" Value="600"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="700"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.007143" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="700"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.20.1.0" Value="700"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.001190" DistinctValues="0.250000">
          <dxl:LowerBound Closed="false" TypeMdid="0.20.1.0" Value="700"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="800"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.004762" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="800"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.20.1.0" Value="800"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.000786" DistinctValues="0.165000">
          <dxl:LowerBound Closed="false" TypeMdid="0.20.1.0" Value="800"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="866"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.002381" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="866"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.20.1.0" Value="866"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.000405" DistinctValues="0.085000">
          <dxl:LowerBound Closed="false" TypeMdid="0.20.1.0" Value="866"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="900"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.004762" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="900"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.20.1.0" Value="900"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.001190" DistinctValues="0.250000">
          <dxl:LowerBound Closed="false" TypeMdid="0.20.1.0" Value="900"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="1000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.028571" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="1000"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.20.1.0" Value="1000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.001429" DistinctValues="0.337500">
          <dxl:LowerBound Closed="false" TypeMdid="0.20.1.0" Value="1000"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="1300"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.002381" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="1300"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.20.1.0" Value="1300"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.002381" DistinctValues="0.562500">
          <dxl:LowerBound Closed="false" TypeMdid="0.20.1.0" Value="1300"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="1800"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.002381" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="1800"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.20.1.0" Value="1800"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.000400" DistinctValues="0.094500">
          <dxl:LowerBound Closed="false" TypeMdid="0.20.1.0" Value="1800"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="1884"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.002381" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="1884"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.20.1.0" Value="1884"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.000552" DistinctValues="0.130500">
          <dxl:LowerBound Closed="false" TypeMdid="0.20.1.0" Value="1884"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="2000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.004762" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="2000"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.20.1.0" Value="2000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.004762" DistinctValues="3.125000">
          <dxl:LowerBound Closed="false" TypeMdid="0.20.1.0" Value="2000"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="4000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.002381" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="4000"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.20.1.0" Value="4000"/>
        </dxl:StatsBucket>
      </dxl:ColumnStatistics>
      <dxl:ColumnStatistics Mdid="1.16166631.1.1.2" Name="trade_price" Width="8.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000">
        <dxl:StatsBucket Frequency="0.003380" DistinctValues="0.666667">
          <dxl:LowerBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAAQAHgF" DoubleValue="161400.000000"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAAQANwF" DoubleValue="161500.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.014286" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAAQANwF" DoubleValue="161500.000000"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAAQANwF" DoubleValue="161500.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.016902" DistinctValues="3.333333">
          <dxl:LowerBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAAQANwF" DoubleValue="161500.000000"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAAQANAH" DoubleValue="162000.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.020282" DistinctValues="5.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAAQANAH" DoubleValue="162000.000000"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAAQAIwK" DoubleValue="162700.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.020282" DistinctValues="5.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAAQAIwK" DoubleValue="162700.000000"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAAQAKwN" DoubleValue="163500.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.020282" DistinctValues="5.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAAQAKwN" DoubleValue="163500.000000"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAAQALQU" DoubleValue="165300.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.020282" DistinctValues="5.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAAQALQU" DoubleValue="165300.000000"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAAQAHwV" DoubleValue="165500.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.019048" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAAQAHwV" DoubleValue="165500.000000"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAAQAHwV" DoubleValue="165500.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.020274" DistinctValues="2.998788">
          <dxl:LowerBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAAQAHwV" DoubleValue="165500.000000"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApALgL" DoubleValue="413000.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.019048" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApALgL" DoubleValue="413000.000000"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApALgL" DoubleValue="413000.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.000008" DistinctValues="0.001212">
          <dxl:LowerBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApALgL" DoubleValue="413000.000000"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApABwM" DoubleValue="413100.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.015174" DistinctValues="2.992519">
          <dxl:LowerBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApABwM" DoubleValue="413100.000000"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAEgN" DoubleValue="413400.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.014286" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAEgN" DoubleValue="413400.000000"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAEgN" DoubleValue="413400.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.005108" DistinctValues="1.007481">
          <dxl:LowerBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAEgN" DoubleValue="413400.000000"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAK0N" DoubleValue="413501.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.013499" DistinctValues="2.662207">
          <dxl:LowerBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAK0N" DoubleValue="413501.000000"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAHQO" DoubleValue="413700.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.019048" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAHQO" DoubleValue="413700.000000"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAHQO" DoubleValue="413700.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.006783" DistinctValues="1.337793">
          <dxl:LowerBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAHQO" DoubleValue="413700.000000"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApANgO" DoubleValue="413800.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.021429" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApANgO" DoubleValue="413800.000000"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApANgO" DoubleValue="413800.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.010141" DistinctValues="1.500000">
          <dxl:LowerBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApANgO" DoubleValue="413800.000000"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApADwP" DoubleValue="413900.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.014286" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApADwP" DoubleValue="413900.000000"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApADwP" DoubleValue="413900.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.010141" DistinctValues="1.500000">
          <dxl:LowerBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApADwP" DoubleValue="413900.000000"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAKAP" DoubleValue="414000.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.014286" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAKAP" DoubleValue="414000.000000"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAKAP" DoubleValue="414000.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.006761" DistinctValues="0.666667">
          <dxl:LowerBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAKAP" DoubleValue="414000.000000"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAAQQ" DoubleValue="414100.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.014286" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAAQQ" DoubleValue="414100.000000"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAAQQ" DoubleValue="414100.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.006761" DistinctValues="0.666667">
          <dxl:LowerBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAAQQ" DoubleValue="414100.000000"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAGgQ" DoubleValue="414200.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.014286" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAGgQ" DoubleValue="414200.000000"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAGgQ" DoubleValue="414200.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.006761" DistinctValues="0.666667">
          <dxl:LowerBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAGgQ" DoubleValue="414200.000000"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAMwQ" DoubleValue="414300.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.010141" DistinctValues="2.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAMwQ" DoubleValue="414300.000000"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApADAR" DoubleValue="414400.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.023810" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApADAR" DoubleValue="414400.000000"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApADAR" DoubleValue="414400.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.010141" DistinctValues="2.000000">
          <dxl:LowerBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApADAR" DoubleValue="414400.000000"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAJQR" DoubleValue="414500.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.016667" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAJQR" DoubleValue="414500.000000"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAJQR" DoubleValue="414500.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.006761" DistinctValues="1.000000">
          <dxl:LowerBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAJQR" DoubleValue="414500.000000"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAPgR" DoubleValue="414600.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.014286" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAPgR" DoubleValue="414600.000000"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAPgR" DoubleValue="414600.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.013521" DistinctValues="2.000000">
          <dxl:LowerBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAPgR" DoubleValue="414600.000000"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAMAS" DoubleValue="414800.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.023810" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAMAS" DoubleValue="414800.000000"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAMAS" DoubleValue="414800.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.020282" DistinctValues="4.000000">
          <dxl:LowerBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAMAS" DoubleValue="414800.000000"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAIgT" DoubleValue="415000.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.035714" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAIgT" DoubleValue="415000.000000"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAIgT" DoubleValue="415000.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.020282" DistinctValues="4.000000">
          <dxl:LowerBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAIgT" DoubleValue="415000.000000"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAOwT" DoubleValue="415100.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.006761" DistinctValues="1.333333">
          <dxl:LowerBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAOwT" DoubleValue="415100.000000"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAFAU" DoubleValue="415200.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.021429" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAFAU" DoubleValue="415200.000000"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAFAU" DoubleValue="415200.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.013521" DistinctValues="2.666667">
          <dxl:LowerBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAFAU" DoubleValue="415200.000000"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApABgV" DoubleValue="415400.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.020282" DistinctValues="5.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApABgV" DoubleValue="415400.000000"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAKYW" DoubleValue="415798.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.005146" DistinctValues="1.014925">
          <dxl:LowerBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAKYW" DoubleValue="415798.000000"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAAwX" DoubleValue="415900.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.016667" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAAwX" DoubleValue="415900.000000"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAAwX" DoubleValue="415900.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.015136" DistinctValues="2.985075">
          <dxl:LowerBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAAwX" DoubleValue="415900.000000"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApADgY" DoubleValue="416200.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.006761" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApADgY" DoubleValue="416200.000000"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAJwY" DoubleValue="416300.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.016667" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAJwY" DoubleValue="416300.000000"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAJwY" DoubleValue="416300.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.006761" DistinctValues="1.000000">
          <dxl:LowerBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAJwY" DoubleValue="416300.000000"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAAAZ" DoubleValue="416400.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.014286" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAAAZ" DoubleValue="416400.000000"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAAAZ" DoubleValue="416400.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.006761" DistinctValues="1.000000">
          <dxl:LowerBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAAAZ" DoubleValue="416400.000000"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAGQZ" DoubleValue="416500.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.020282" DistinctValues="5.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAGQZ" DoubleValue="416500.000000"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApALwb" DoubleValue="417100.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.023810" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApALwb" DoubleValue="417100.000000"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApALwb" DoubleValue="417100.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.010141" DistinctValues="1.500000">
          <dxl:LowerBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApALwb" DoubleValue="417100.000000"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApACAc" DoubleValue="417200.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.014286" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApACAc" DoubleValue="417200.000000"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApACAc" DoubleValue="417200.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.010141" DistinctValues="1.500000">
          <dxl:LowerBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApACAc" DoubleValue="417200.000000"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAIQc" DoubleValue="417300.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.020282" DistinctValues="5.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAIQc" DoubleValue="417300.000000"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAGwg" DoubleValue="418300.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.020282" DistinctValues="5.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAGwg" DoubleValue="418300.000000"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAMQi" DoubleValue="418900.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.020282" DistinctValues="5.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAMQi" DoubleValue="418900.000000"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApALgk" DoubleValue="419400.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.021429" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApALgk" DoubleValue="419400.000000"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApALgk" DoubleValue="419400.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.020282" DistinctValues="4.000000">
          <dxl:LowerBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApALgk" DoubleValue="419400.000000"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAOQl" DoubleValue="419700.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.010141" DistinctValues="2.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAOQl" DoubleValue="419700.000000"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAEgm" DoubleValue="419800.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.016667" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAEgm" DoubleValue="419800.000000"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAEgm" DoubleValue="419800.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.010141" DistinctValues="2.000000">
          <dxl:LowerBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAEgm" DoubleValue="419800.000000"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAKwm" DoubleValue="419900.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.014286" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAKwm" DoubleValue="419900.000000"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAKwm" DoubleValue="419900.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.015212" DistinctValues="2.250000">
          <dxl:LowerBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAApAKwm" DoubleValue="419900.000000"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAAqAMgA" DoubleValue="420200.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.014286" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAAqAMgA" DoubleValue="420200.000000"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAAqAMgA" DoubleValue="420200.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.005071" DistinctValues="0.750000">
          <dxl:LowerBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAAqAMgA" DoubleValue="420200.000000"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.1700.1.0" Value="AAAADAEAAAAqACwB" DoubleValue="420300.000000"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.020282" DistinctValues="5.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAAqACwB" DoubleValue="420300.000000"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.1700.1.0" Value="AAAADAEAAAAqAJAB" DoubleValue="420400.000000"/>
        </dxl:StatsBucket>
      </dxl:ColumnStatistics>
      <dxl:MDCast Mdid="3.1043.1.0;1042.1.0" Name="bpchar" BinaryCoercible="true" SourceTypeId="0.1043.1.0" DestinationTypeId="0.1042.1.0" CastFuncId="0.0.0.0"/>
      <dxl:Type Mdid="0.29.1.0" Name="cid" IsRedistributable="false" IsHashable="true" IsMergeJoinable="false" IsComposite="false" IsFixedLength="true" Length="4" PassByValue="true">
        <dxl:EqualityOp Mdid="0.385.1.0"/>
        <dxl:InequalityOp Mdid="0.0.0.0"/>
        <dxl:LessThanOp Mdid="0.0.0.0"/>
        <dxl:LessThanEqualsOp Mdid="0.0.0.0"/>
        <dxl:GreaterThanOp Mdid="0.0.0.0"/>
        <dxl:GreaterThanEqualsOp Mdid="0.0.0.0"/>
        <dxl:ComparisonOp Mdid="0.0.0.0"/>
        <dxl:ArrayType Mdid="0.1012.1.0"/>
        <dxl:MinAgg Mdid="0.0.0.0"/>
        <dxl:MaxAgg Mdid="0.0.0.0"/>
        <dxl:AvgAgg Mdid="0.0.0.0"/>
        <dxl:SumAgg Mdid="0.0.0.0"/>
        <dxl:CountAgg Mdid="0.2147.1.0"/>
      </dxl:Type>
      <dxl:Type Mdid="0.28.1.0" Name="xid" IsRedistributable="false" IsHashable="true" IsMergeJoinable="false" IsComposite="false" IsFixedLength="true" Length="4" PassByValue="true">
        <dxl:EqualityOp Mdid="0.352.1.0"/>
        <dxl:InequalityOp Mdid="0.0.0.0"/>
        <dxl:LessThanOp Mdid="0.0.0.0"/>
        <dxl:LessThanEqualsOp Mdid="0.0.0.0"/>
        <dxl:GreaterThanOp Mdid="0.0.0.0"/>
        <dxl:GreaterThanEqualsOp Mdid="0.0.0.0"/>
        <dxl:ComparisonOp Mdid="0.0.0.0"/>
        <dxl:ArrayType Mdid="0.1011.1.0"/>
        <dxl:MinAgg Mdid="0.0.0.0"/>
        <dxl:MaxAgg Mdid="0.0.0.0"/>
        <dxl:AvgAgg Mdid="0.0.0.0"/>
        <dxl:SumAgg Mdid="0.0.0.0"/>
        <dxl:CountAgg Mdid="0.2147.1.0"/>
      </dxl:Type>
      <dxl:GPDBScalarOp Mdid="0.412.1.0" Name="&lt;" ComparisonType="LT" ReturnsNullOnNullInput="true">
        <dxl:LeftType Mdid="0.20.1.0"/>
        <dxl:RightType Mdid="0.20.1.0"/>
        <dxl:ResultType Mdid="0.16.1.0"/>
        <dxl:OpFunc Mdid="0.469.1.0"/>
        <dxl:Commutator Mdid="0.413.1.0"/>
        <dxl:InverseOp Mdid="0.415.1.0"/>
        <dxl:Opfamilies>
          <dxl:Opfamily Mdid="0.1980.1.0"/>
          <dxl:Opfamily Mdid="0.3028.1.0"/>
        </dxl:Opfamilies>
      </dxl:GPDBScalarOp>
      <dxl:GPDBScalarOp Mdid="0.414.1.0" Name="&lt;=" ComparisonType="LEq" ReturnsNullOnNullInput="true">
        <dxl:LeftType Mdid="0.20.1.0"/>
        <dxl:RightType Mdid="0.20.1.0"/>
        <dxl:ResultType Mdid="0.16.1.0"/>
        <dxl:OpFunc Mdid="0.471.1.0"/>
        <dxl:Commutator Mdid="0.415.1.0"/>
        <dxl:InverseOp Mdid="0.413.1.0"/>
        <dxl:Opfamilies>
          <dxl:Opfamily Mdid="0.1980.1.0"/>
          <dxl:Opfamily Mdid="0.3028.1.0"/>
        </dxl:Opfamilies>
      </dxl:GPDBScalarOp>
      <dxl:GPDBScalarOp Mdid="0.415.1.0" Name="&gt;=" ComparisonType="GEq" ReturnsNullOnNullInput="true">
        <dxl:LeftType Mdid="0.20.1.0"/>
        <dxl:RightType Mdid="0.20.1.0"/>
        <dxl:ResultType Mdid="0.16.1.0"/>
        <dxl:OpFunc Mdid="0.472.1.0"/>
        <dxl:Commutator Mdid="0.414.1.0"/>
        <dxl:InverseOp Mdid="0.412.1.0"/>
        <dxl:Opfamilies>
          <dxl:Opfamily Mdid="0.1980.1.0"/>
          <dxl:Opfamily Mdid="0.3028.1.0"/>
        </dxl:Opfamilies>
      </dxl:GPDBScalarOp>
      <dxl:GPDBScalarOp Mdid="0.1054.1.0" Name="=" ComparisonType="Eq" ReturnsNullOnNullInput="true">
        <dxl:LeftType Mdid="0.1042.1.0"/>
        <dxl:RightType Mdid="0.1042.1.0"/>
        <dxl:ResultType Mdid="0.16.1.0"/>
        <dxl:OpFunc Mdid="0.1048.1.0"/>
        <dxl:Commutator Mdid="0.1054.1.0"/>
        <dxl:InverseOp Mdid="0.1057.1.0"/>
        <dxl:Opfamilies>
          <dxl:Opfamily Mdid="0.426.1.0"/>
          <dxl:Opfamily Mdid="0.427.1.0"/>
          <dxl:Opfamily Mdid="0.3018.1.0"/>
        </dxl:Opfamilies>
      </dxl:GPDBScalarOp>
      <dxl:Type Mdid="0.1700.1.0" Name="numeric" IsRedistributable="true" IsHashable="true" IsMergeJoinable="true" IsComposite="false" IsFixedLength="false" Length="-1" PassByValue="false">
        <dxl:EqualityOp Mdid="0.1752.1.0"/>
        <dxl:InequalityOp Mdid="0.1753.1.0"/>
        <dxl:LessThanOp Mdid="0.1754.1.0"/>
        <dxl:LessThanEqualsOp Mdid="0.1755.1.0"/>
        <dxl:GreaterThanOp Mdid="0.1756.1.0"/>
        <dxl:GreaterThanEqualsOp Mdid="0.1757.1.0"/>
        <dxl:ComparisonOp Mdid="0.1769.1.0"/>
        <dxl:ArrayType Mdid="0.1231.1.0"/>
        <dxl:MinAgg Mdid="0.2146.1.0"/>
        <dxl:MaxAgg Mdid="0.2130.1.0"/>
        <dxl:AvgAgg Mdid="0.2103.1.0"/>
        <dxl:SumAgg Mdid="0.2114.1.0"/>
        <dxl:CountAgg Mdid="0.2147.1.0"/>
      </dxl:Type>
      <dxl:Index Mdid="0.16166830.1.0" Name="my_tq_agg_small_ets_end_ts_ix_1_prt_p1" IsClustered="false" IndexType="B-tree" KeyColumns="0,4" IncludedColumns="0,1,2,3,4,5,6,7,8,9,10,11">
        <dxl:Opfamilies>
          <dxl:Opfamily Mdid="0.1980.1.0"/>
          <dxl:Opfamily Mdid="0.1980.1.0"/>
        </dxl:Opfamilies>
        <dxl:PartConstraint DefaultPartition="" Unbounded="false">
          <dxl:And>
            <dxl:Comparison ComparisonOperator="&gt;=" OperatorMdid="0.1757.1.0">
              <dxl:Ident ColId="3" ColName="bid_price" TypeMdid="0.1700.1.0"/>
              <dxl:ConstValue TypeMdid="0.1700.1.0" Value="AAAACgAAAAABAA==" DoubleValue="1.000000"/>
            </dxl:Comparison>
            <dxl:Comparison ComparisonOperator="&lt;" OperatorMdid="0.1754.1.0">
              <dxl:Ident ColId="3" ColName="bid_price" TypeMdid="0.1700.1.0"/>
              <dxl:ConstValue TypeMdid="0.1700.1.0" Value="AAAACgEAAABaAA==" DoubleValue="900000.000000"/>
            </dxl:Comparison>
          </dxl:And>
        </dxl:PartConstraint>
      </dxl:Index>
      <dxl:GPDBScalarOp Mdid="0.691.1.0" Name="/" ComparisonType="Other" ReturnsNullOnNullInput="true">
        <dxl:LeftType Mdid="0.20.1.0"/>
        <dxl:RightType Mdid="0.23.1.0"/>
        <dxl:ResultType Mdid="0.20.1.0"/>
        <dxl:OpFunc Mdid="0.1277.1.0"/>
      </dxl:GPDBScalarOp>
      <dxl:GPDBScalarOp Mdid="0.690.1.0" Name="*" ComparisonType="Other" ReturnsNullOnNullInput="true">
        <dxl:LeftType Mdid="0.20.1.0"/>
        <dxl:RightType Mdid="0.23.1.0"/>
        <dxl:ResultType Mdid="0.20.1.0"/>
        <dxl:OpFunc Mdid="0.1276.1.0"/>
        <dxl:Commutator Mdid="0.694.1.0"/>
      </dxl:GPDBScalarOp>
      <dxl:ColumnStatistics Mdid="1.16166659.1.1.9" Name="cmax" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000"/>
      <dxl:ColumnStatistics Mdid="1.16166659.1.1.8" Name="xmax" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000"/>
      <dxl:ColumnStatistics Mdid="1.16166659.1.1.1" Name="sym" Width="8.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000"/>
      <dxl:ColumnStatistics Mdid="1.16166659.1.1.0" Name="ets" Width="8.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000"/>
      <dxl:ColumnStatistics Mdid="1.16166631.1.1.9" Name="tableoid" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000"/>
      <dxl:ColumnStatistics Mdid="1.16166631.1.1.8" Name="cmax" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000"/>
      <dxl:ColumnStatistics Mdid="1.16166631.1.1.1" Name="event_ts" Width="8.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000">
        <dxl:StatsBucket Frequency="0.010231" DistinctValues="4.286066">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="20101126101210755"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="20101126101403752"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.002381" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="20101126101403752"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.20.1.0" Value="20101126101403752"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.023896" DistinctValues="10.010230">
          <dxl:LowerBound Closed="false" TypeMdid="0.20.1.0" Value="20101126101403752"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="20101126101854502"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.001627" DistinctValues="0.633952">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="20101126101854502"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="20101126101909312"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.002381" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="20101126101909312"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.20.1.0" Value="20101126101909312"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.021454" DistinctValues="8.358709">
          <dxl:LowerBound Closed="false" TypeMdid="0.20.1.0" Value="20101126101909312"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="20101126102631986"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.002381" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="20101126102631986"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.20.1.0" Value="20101126102631986"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.011046" DistinctValues="4.303635">
          <dxl:LowerBound Closed="false" TypeMdid="0.20.1.0" Value="20101126102631986"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="20101126103004068"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.034127" DistinctValues="15.296296">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="20101126103004068"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="20101126103624657"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.034127" DistinctValues="15.296296">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="20101126103624657"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="20101126104655754"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.025533" DistinctValues="10.695945">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="20101126104655754"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="20101126105235896"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.002381" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="20101126105235896"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.20.1.0" Value="20101126105235896"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.008594" DistinctValues="3.600351">
          <dxl:LowerBound Closed="false" TypeMdid="0.20.1.0" Value="20101126105235896"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="20101126105431177"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.007072" DistinctValues="2.962356">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="20101126105431177"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="20101126105517786"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.007143" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="20101126105517786"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.20.1.0" Value="20101126105517786"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.027055" DistinctValues="11.333940">
          <dxl:LowerBound Closed="false" TypeMdid="0.20.1.0" Value="20101126105517786"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="20101126105849151"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.034127" DistinctValues="15.296296">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="20101126105849151"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="20101126111754263"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.029075" DistinctValues="12.180146">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="20101126111754263"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="20101126112944097"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.004762" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="20101126112944097"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.20.1.0" Value="20101126112944097"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.005052" DistinctValues="2.116150">
          <dxl:LowerBound Closed="false" TypeMdid="0.20.1.0" Value="20101126112944097"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="20101126113150816"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.022146" DistinctValues="9.277354">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="20101126113150816"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="20101126113409949"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.002381" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="20101126113409949"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.20.1.0" Value="20101126113409949"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.011981" DistinctValues="5.018943">
          <dxl:LowerBound Closed="false" TypeMdid="0.20.1.0" Value="20101126113409949"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="20101126113550137"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.004175" DistinctValues="1.748827">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="20101126113550137"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="20101126113636841"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.004762" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="20101126113636841"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.20.1.0" Value="20101126113636841"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.029952" DistinctValues="12.547469">
          <dxl:LowerBound Closed="false" TypeMdid="0.20.1.0" Value="20101126113636841"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="20101126114258924"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.025729" DistinctValues="10.778124">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="20101126114258924"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="20101126114622409"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.002381" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="20101126114622409"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.20.1.0" Value="20101126114622409"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.008398" DistinctValues="3.518172">
          <dxl:LowerBound Closed="false" TypeMdid="0.20.1.0" Value="20101126114622409"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="20101126114741057"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.034127" DistinctValues="15.296296">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="20101126114741057"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="20101126115245995"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.034127" DistinctValues="15.296296">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="20101126115245995"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="20101126120604250"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.010437" DistinctValues="3.760677">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="20101126120604250"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="20101126120946382"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.002381" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="20101126120946382"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.20.1.0" Value="20101126120946382"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.001701" DistinctValues="0.612941">
          <dxl:LowerBound Closed="false" TypeMdid="0.20.1.0" Value="20101126120946382"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="20101126121002145"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.002381" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="20101126121002145"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.20.1.0" Value="20101126121002145"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.018908" DistinctValues="6.812817">
          <dxl:LowerBound Closed="false" TypeMdid="0.20.1.0" Value="20101126121002145"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="20101126121621949"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.004762" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="20101126121621949"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.20.1.0" Value="20101126121621949"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.003080" DistinctValues="1.109862">
          <dxl:LowerBound Closed="false" TypeMdid="0.20.1.0" Value="20101126121621949"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="20101126121722920"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.000042" DistinctValues="0.013791">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="20101126121722920"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="20101126121724725"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.002381" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="20101126121724725"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.20.1.0" Value="20101126121724725"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.023893" DistinctValues="7.908631">
          <dxl:LowerBound Closed="false" TypeMdid="0.20.1.0" Value="20101126121724725"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="20101126122759847"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.002381" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="20101126122759847"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.20.1.0" Value="20101126122759847"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.002106" DistinctValues="0.697184">
          <dxl:LowerBound Closed="false" TypeMdid="0.20.1.0" Value="20101126122759847"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="20101126122851098"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.002381" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="20101126122851098"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.20.1.0" Value="20101126122851098"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.004351" DistinctValues="1.440202">
          <dxl:LowerBound Closed="false" TypeMdid="0.20.1.0" Value="20101126122851098"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="20101126123039599"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.002381" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="20101126123039599"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.20.1.0" Value="20101126123039599"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.003736" DistinctValues="1.236489">
          <dxl:LowerBound Closed="false" TypeMdid="0.20.1.0" Value="20101126123039599"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="20101126123201437"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.021255" DistinctValues="8.903902">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="20101126123201437"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="20101126124225712"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.002381" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="20101126124225712"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.20.1.0" Value="20101126124225712"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.012872" DistinctValues="5.392395">
          <dxl:LowerBound Closed="false" TypeMdid="0.20.1.0" Value="20101126124225712"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="20101126124846035"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.033061" DistinctValues="13.849651">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="20101126124846035"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="20101126130431657"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.004762" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="20101126130431657"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.20.1.0" Value="20101126130431657"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.001066" DistinctValues="0.446646">
          <dxl:LowerBound Closed="false" TypeMdid="0.20.1.0" Value="20101126130431657"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="20101126130611791"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.014125" DistinctValues="5.089231">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="20101126130611791"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="20101126130704392"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.004762" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="20101126130704392"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.20.1.0" Value="20101126130704392"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.002824" DistinctValues="1.017670">
          <dxl:LowerBound Closed="false" TypeMdid="0.20.1.0" Value="20101126130704392"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="20101126130722909"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.002381" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="20101126130722909"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.20.1.0" Value="20101126130722909"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.012786" DistinctValues="4.606859">
          <dxl:LowerBound Closed="false" TypeMdid="0.20.1.0" Value="20101126130722909"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="20101126130806733"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.002381" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="20101126130806733"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.20.1.0" Value="20101126130806733"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.004392" DistinctValues="1.582536">
          <dxl:LowerBound Closed="false" TypeMdid="0.20.1.0" Value="20101126130806733"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="20101126130835528"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.034127" DistinctValues="15.296296">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="20101126130835528"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="20101126131917795"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.034127" DistinctValues="15.296296">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="20101126131917795"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="20101126132643539"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.034127" DistinctValues="15.296296">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="20101126132643539"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="20101126134523280"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.002381" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="20101126134523280"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.20.1.0" Value="20101126134523280"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.009053" DistinctValues="2.996460">
          <dxl:LowerBound Closed="false" TypeMdid="0.20.1.0" Value="20101126134523280"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="20101126134848481"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.002381" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="20101126134848481"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.20.1.0" Value="20101126134848481"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.003070" DistinctValues="1.016038">
          <dxl:LowerBound Closed="false" TypeMdid="0.20.1.0" Value="20101126134848481"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="20101126134958750"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.002381" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="20101126134958750"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.20.1.0" Value="20101126134958750"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.010424" DistinctValues="3.450581">
          <dxl:LowerBound Closed="false" TypeMdid="0.20.1.0" Value="20101126134958750"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="20101126135333236"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.004762" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="20101126135333236"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.20.1.0" Value="20101126135333236"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.011580" DistinctValues="3.833218">
          <dxl:LowerBound Closed="false" TypeMdid="0.20.1.0" Value="20101126135333236"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="20101126135749249"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.034127" DistinctValues="15.296296">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="20101126135749249"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="20101126140744197"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.034127" DistinctValues="15.296296">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="20101126140744197"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="20101126141653600"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.034127" DistinctValues="15.296296">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="20101126141653600"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="20101126142750870"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.034127" DistinctValues="15.296296">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="20101126142750870"/>
          <dxl:UpperBound Closed="false" TypeMdid="0.20.1.0" Value="20101126143632686"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.034127" DistinctValues="15.296296">
          <dxl:LowerBound Closed="true" TypeMdid="0.20.1.0" Value="20101126143632686"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.20.1.0" Value="20101126143910661"/>
        </dxl:StatsBucket>
      </dxl:ColumnStatistics>
      <dxl:ColumnStatistics Mdid="1.16166631.1.1.0" Name="symbol" Width="17.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000">
        <dxl:StatsBucket Frequency="0.202381" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.1042.1.0" Value="AAAAFFNGRCAgICAgICAgICAgICA=" LintValue="950"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.1042.1.0" Value="AAAAFFNGRCAgICAgICAgICAgICA=" LintValue="950"/>
        </dxl:StatsBucket>
        <dxl:StatsBucket Frequency="0.797619" DistinctValues="1.000000">
          <dxl:LowerBound Closed="true" TypeMdid="0.1042.1.0" Value="AAAAFFNTTyAgICAgICAgICAgICA=" LintValue="33555254"/>
          <dxl:UpperBound Closed="true" TypeMdid="0.1042.1.0" Value="AAAAFFNTTyAgICAgICAgICAgICA=" LintValue="33555254"/>
        </dxl:StatsBucket>
      </dxl:ColumnStatistics>
      <dxl:GPDBFunc Mdid="0.6083.1.0" Name="gp_partition_propagation" ReturnsSet="false" Stability="Volatile" DataAccess="NoSQL" IsStrict="true">
        <dxl:ResultType Mdid="0.2278.1.0"/>
      </dxl:GPDBFunc>
      <dxl:GPDBFunc Mdid="0.6085.1.0" Name="gp_partition_expansion" ReturnsSet="true" Stability="Stable" DataAccess="NoSQL" IsStrict="true">
        <dxl:ResultType Mdid="0.26.1.0"/>
      </dxl:GPDBFunc>
      <dxl:GPDBScalarOp Mdid="0.1754.1.0" Name="&lt;" ComparisonType="LT" ReturnsNullOnNullInput="true">
        <dxl:LeftType Mdid="0.1700.1.0"/>
        <dxl:RightType Mdid="0.1700.1.0"/>
        <dxl:ResultType Mdid="0.16.1.0"/>
        <dxl:OpFunc Mdid="0.1722.1.0"/>
        <dxl:Commutator Mdid="0.1756.1.0"/>
        <dxl:InverseOp Mdid="0.1757.1.0"/>
        <dxl:Opfamilies>
          <dxl:Opfamily Mdid="0.1988.1.0"/>
          <dxl:Opfamily Mdid="0.3032.1.0"/>
        </dxl:Opfamilies>
      </dxl:GPDBScalarOp>
      <dxl:ColumnStatistics Mdid="1.16166659.1.1.7" Name="cmin" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000"/>
      <dxl:ColumnStatistics Mdid="1.16166659.1.1.6" Name="xmin" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000"/>
      <dxl:ColumnStatistics Mdid="1.16166631.1.1.7" Name="xmax" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000"/>
      <dxl:ColumnStatistics Mdid="1.16166631.1.1.6" Name="cmin" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000"/>
      <dxl:GPDBScalarOp Mdid="0.1757.1.0" Name="&gt;=" ComparisonType="GEq" ReturnsNullOnNullInput="true">
        <dxl:LeftType Mdid="0.1700.1.0"/>
        <dxl:RightType Mdid="0.1700.1.0"/>
        <dxl:ResultType Mdid="0.16.1.0"/>
        <dxl:OpFunc Mdid="0.1721.1.0"/>
        <dxl:Commutator Mdid="0.1755.1.0"/>
        <dxl:InverseOp Mdid="0.1754.1.0"/>
        <dxl:Opfamilies>
          <dxl:Opfamily Mdid="0.1988.1.0"/>
          <dxl:Opfamily Mdid="0.3032.1.0"/>
        </dxl:Opfamilies>
      </dxl:GPDBScalarOp>
      <dxl:RelationStatistics Mdid="2.16166631.1.1" Name="my_tt_agg_small" Rows="420.000000" EmptyRelation="false"/>
      <dxl:Relation Mdid="6.16166631.1.1" Name="my_tt_agg_small" IsTemporary="false" HasOids="false" StorageType="Heap" DistributionPolicy="Hash" DistributionColumns="0" Keys="10,4">
        <dxl:Columns>
          <dxl:Column Name="symbol" Attno="1" Mdid="0.1042.1.0" Nullable="true" ColWidth="16">
            <dxl:DefaultValue/>
          </dxl:Column>
          <dxl:Column Name="event_ts" Attno="2" Mdid="0.20.1.0" Nullable="true" ColWidth="8">
            <dxl:DefaultValue/>
          </dxl:Column>
          <dxl:Column Name="trade_price" Attno="3" Mdid="0.1700.1.0" Nullable="true" ColWidth="8">
            <dxl:DefaultValue/>
          </dxl:Column>
          <dxl:Column Name="trade_volume" Attno="4" Mdid="0.20.1.0" Nullable="true" ColWidth="8">
            <dxl:DefaultValue/>
          </dxl:Column>
          <dxl:Column Name="ctid" Attno="-1" Mdid="0.27.1.0" Nullable="false" ColWidth="6">
            <dxl:DefaultValue/>
          </dxl:Column>
          <dxl:Column Name="xmin" Attno="-3" Mdid="0.28.1.0" Nullable="false" ColWidth="4">
            <dxl:DefaultValue/>
          </dxl:Column>
          <dxl:Column Name="cmin" Attno="-4" Mdid="0.29.1.0" Nullable="false" ColWidth="4">
            <dxl:DefaultValue/>
          </dxl:Column>
          <dxl:Column Name="xmax" Attno="-5" Mdid="0.28.1.0" Nullable="false" ColWidth="4">
            <dxl:DefaultValue/>
          </dxl:Column>
          <dxl:Column Name="cmax" Attno="-6" Mdid="0.29.1.0" Nullable="false" ColWidth="4">
            <dxl:DefaultValue/>
          </dxl:Column>
          <dxl:Column Name="tableoid" Attno="-7" Mdid="0.26.1.0" Nullable="false" ColWidth="4">
            <dxl:DefaultValue/>
          </dxl:Column>
          <dxl:Column Name="gp_segment_id" Attno="-8" Mdid="0.23.1.0" Nullable="false" ColWidth="4">
            <dxl:DefaultValue/>
          </dxl:Column>
        </dxl:Columns>
        <dxl:IndexInfoList/>
        <dxl:Triggers/>
        <dxl:CheckConstraints/>
      </dxl:Relation>
      <dxl:Type Mdid="0.2278.1.0" Name="void" IsRedistributable="false" IsHashable="false" IsMergeJoinable="false" IsComposite="false" IsFixedLength="true" Length="4" PassByValue="true">
        <dxl:EqualityOp Mdid="0.0.0.0"/>
        <dxl:InequalityOp Mdid="0.0.0.0"/>
        <dxl:LessThanOp Mdid="0.0.0.0"/>
        <dxl:LessThanEqualsOp Mdid="0.0.0.0"/>
        <dxl:GreaterThanOp Mdid="0.0.0.0"/>
        <dxl:GreaterThanEqualsOp Mdid="0.0.0.0"/>
        <dxl:ComparisonOp Mdid="0.0.0.0"/>
        <dxl:ArrayType Mdid="0.0.0.0"/>
        <dxl:MinAgg Mdid="0.0.0.0"/>
        <dxl:MaxAgg Mdid="0.0.0.0"/>
        <dxl:AvgAgg Mdid="0.0.0.0"/>
        <dxl:SumAgg Mdid="0.0.0.0"/>
        <dxl:CountAgg Mdid="0.2147.1.0"/>
      </dxl:Type>
      <dxl:ColumnStatistics Mdid="1.16166659.1.1.5" Name="ctid" Width="6.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000"/>
      <dxl:ColumnStatistics Mdid="1.16166659.1.1.4" Name="end_ts" Width="8.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000"/>
      <dxl:ColumnStatistics Mdid="1.16166631.1.1.5" Name="xmin" Width="4.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000"/>
      <dxl:ColumnStatistics Mdid="1.16166631.1.1.4" Name="ctid" Width="6.000000" NullFreq="0.000000" NdvRemain="0.000000" FreqRemain="0.000000"/>
    </dxl:Metadata>
    <dxl:Query>
      <dxl:OutputColumns>
        <dxl:Ident ColId="24" ColName="fivemin" TypeMdid="0.20.1.0"/>
      </dxl:OutputColumns>
      <dxl:CTEList/>
      <dxl:LogicalLimit>
        <dxl:SortingColumnList>
          <dxl:SortingColumn ColId="24" SortOperatorMdid="0.412.1.0" SortOperatorName="&lt;" SortNullsFirst="false"/>
        </dxl:SortingColumnList>
        <dxl:LimitCount/>
        <dxl:LimitOffset/>
        <dxl:LogicalGroupBy>
          <dxl:GroupingColumns>
            <dxl:GroupingColumn ColId="24"/>
          </dxl:GroupingColumns>
          <dxl:ProjList/>
          <dxl:LogicalProject>
            <dxl:ProjList>
              <dxl:ProjElem ColId="24" Alias="fivemin">
                <dxl:OpExpr OperatorName="*" OperatorMdid="0.690.1.0" OperatorType="0.20.1.0">
                  <dxl:OpExpr OperatorName="/" OperatorMdid="0.691.1.0" OperatorType="0.20.1.0">
                    <dxl:OpExpr OperatorName="/" OperatorMdid="0.691.1.0" OperatorType="0.20.1.0">
                      <dxl:Ident ColId="2" ColName="event_ts" TypeMdid="0.20.1.0"/>
                      <dxl:ConstValue TypeMdid="0.23.1.0" Value="100000"/>
                    </dxl:OpExpr>
                    <dxl:ConstValue TypeMdid="0.23.1.0" Value="5"/>
                  </dxl:OpExpr>
                  <dxl:ConstValue TypeMdid="0.23.1.0" Value="5"/>
                </dxl:OpExpr>
              </dxl:ProjElem>
            </dxl:ProjList>
            <dxl:LogicalJoin JoinType="Inner">
              <dxl:LogicalGet>
                <dxl:TableDescriptor Mdid="6.16166631.1.1" TableName="my_tt_agg_small">
                  <dxl:Columns>
                    <dxl:Column ColId="1" Attno="1" ColName="symbol" TypeMdid="0.1042.1.0" ColWidth="16"/>
                    <dxl:Column ColId="2" Attno="2" ColName="event_ts" TypeMdid="0.20.1.0"/>
                    <dxl:Column ColId="3" Attno="3" ColName="trade_price" TypeMdid="0.1700.1.0"/>
                    <dxl:Column ColId="4" Attno="4" ColName="trade_volume" TypeMdid="0.20.1.0"/>
                    <dxl:Column ColId="5" Attno="-1" ColName="ctid" TypeMdid="0.27.1.0"/>
                    <dxl:Column ColId="6" Attno="-3" ColName="xmin" TypeMdid="0.28.1.0"/>
                    <dxl:Column ColId="7" Attno="-4" ColName="cmin" TypeMdid="0.29.1.0"/>
                    <dxl:Column ColId="8" Attno="-5" ColName="xmax" TypeMdid="0.28.1.0"/>
                    <dxl:Column ColId="9" Attno="-6" ColName="cmax" TypeMdid="0.29.1.0"/>
                    <dxl:Column ColId="10" Attno="-7" ColName="tableoid" TypeMdid="0.26.1.0"/>
                    <dxl:Column ColId="11" Attno="-8" ColName="gp_segment_id" TypeMdid="0.23.1.0"/>
                  </dxl:Columns>
                </dxl:TableDescriptor>
              </dxl:LogicalGet>
              <dxl:LogicalGet>
                <dxl:TableDescriptor Mdid="6.16166659.1.1" TableName="my_tq_agg_small">
                  <dxl:Columns>
                    <dxl:Column ColId="12" Attno="1" ColName="ets" TypeMdid="0.20.1.0"/>
                    <dxl:Column ColId="13" Attno="2" ColName="sym" TypeMdid="0.1043.1.0" ColWidth="16"/>
                    <dxl:Column ColId="14" Attno="3" ColName="bid_price" TypeMdid="0.1700.1.0"/>
                    <dxl:Column ColId="15" Attno="4" ColName="ask_price" TypeMdid="0.1700.1.0"/>
                    <dxl:Column ColId="16" Attno="5" ColName="end_ts" TypeMdid="0.20.1.0"/>
                    <dxl:Column ColId="17" Attno="-1" ColName="ctid" TypeMdid="0.27.1.0"/>
                    <dxl:Column ColId="18" Attno="-3" ColName="xmin" TypeMdid="0.28.1.0"/>
                    <dxl:Column ColId="19" Attno="-4" ColName="cmin" TypeMdid="0.29.1.0"/>
                    <dxl:Column ColId="20" Attno="-5" ColName="xmax" TypeMdid="0.28.1.0"/>
                    <dxl:Column ColId="21" Attno="-6" ColName="cmax" TypeMdid="0.29.1.0"/>
                    <dxl:Column ColId="22" Attno="-7" ColName="tableoid" TypeMdid="0.26.1.0"/>
                    <dxl:Column ColId="23" Attno="-8" ColName="gp_segment_id" TypeMdid="0.23.1.0"/>
                  </dxl:Columns>
                </dxl:TableDescriptor>
              </dxl:LogicalGet>
              <dxl:And>
                <dxl:Comparison ComparisonOperator="=" OperatorMdid="0.1054.1.0">
                  <dxl:Cast TypeMdid="0.1042.1.0" FuncId="0.0.0.0">
                    <dxl:Ident ColId="13" ColName="sym" TypeMdid="0.1043.1.0"/>
                  </dxl:Cast>
                  <dxl:Ident ColId="1" ColName="symbol" TypeMdid="0.1042.1.0"/>
                </dxl:Comparison>
                <dxl:Comparison ComparisonOperator="&gt;=" OperatorMdid="0.415.1.0">
                  <dxl:Ident ColId="2" ColName="event_ts" TypeMdid="0.20.1.0"/>
                  <dxl:Ident ColId="12" ColName="ets" TypeMdid="0.20.1.0"/>
                </dxl:Comparison>
                <dxl:Comparison ComparisonOperator="&lt;" OperatorMdid="0.412.1.0">
                  <dxl:Ident ColId="2" ColName="event_ts" TypeMdid="0.20.1.0"/>
                  <dxl:Ident ColId="16" ColName="end_ts" TypeMdid="0.20.1.0"/>
                </dxl:Comparison>
              </dxl:And>
            </dxl:LogicalJoin>
          </dxl:LogicalProject>
        </dxl:LogicalGroupBy>
      </dxl:LogicalLimit>
    </dxl:Query>
    <dxl:Plan Id="0" SpaceSize="35">
      <dxl:GatherMotion InputSegments="0,1" OutputSegments="-1">
        <dxl:Properties>
          <dxl:Cost StartupCost="0" TotalCost="2951.636128" Rows="1.000000" Width="8"/>
        </dxl:Properties>
        <dxl:ProjList>
          <dxl:ProjElem ColId="23" Alias="fivemin">
            <dxl:Ident ColId="23" ColName="fivemin" TypeMdid="0.20.1.0"/>
          </dxl:ProjElem>
        </dxl:ProjList>
        <dxl:Filter/>
        <dxl:SortingColumnList>
          <dxl:SortingColumn ColId="23" SortOperatorMdid="0.412.1.0" SortOperatorName="&lt;" SortNullsFirst="false"/>
        </dxl:SortingColumnList>
        <dxl:Sort SortDiscardDuplicates="false">
          <dxl:Properties>
            <dxl:Cost StartupCost="0" TotalCost="2951.636092" Rows="1.000000" Width="8"/>
          </dxl:Properties>
          <dxl:ProjList>
            <dxl:ProjElem ColId="23" Alias="fivemin">
              <dxl:Ident ColId="23" ColName="fivemin" TypeMdid="0.20.1.0"/>
            </dxl:ProjElem>
          </dxl:ProjList>
          <dxl:Filter/>
          <dxl:SortingColumnList>
            <dxl:SortingColumn ColId="23" SortOperatorMdid="0.412.1.0" SortOperatorName="&lt;" SortNullsFirst="false"/>
          </dxl:SortingColumnList>
          <dxl:LimitCount/>
          <dxl:LimitOffset/>
          <dxl:Aggregate AggregationStrategy="Sorted" StreamSafe="false">
            <dxl:Properties>
              <dxl:Cost StartupCost="0" TotalCost="2951.636092" Rows="1.000000" Width="8"/>
            </dxl:Properties>
            <dxl:GroupingColumns>
              <dxl:GroupingColumn ColId="23"/>
            </dxl:GroupingColumns>
            <dxl:ProjList>
              <dxl:ProjElem ColId="23" Alias="fivemin">
                <dxl:Ident ColId="23" ColName="fivemin" TypeMdid="0.20.1.0"/>
              </dxl:ProjElem>
            </dxl:ProjList>
            <dxl:Filter/>
            <dxl:Sort SortDiscardDuplicates="false">
              <dxl:Properties>
                <dxl:Cost StartupCost="0" TotalCost="2951.636082" Rows="1.000000" Width="8"/>
              </dxl:Properties>
              <dxl:ProjList>
                <dxl:ProjElem ColId="23" Alias="fivemin">
                  <dxl:Ident ColId="23" ColName="fivemin" TypeMdid="0.20.1.0"/>
                </dxl:ProjElem>
              </dxl:ProjList>
              <dxl:Filter/>
              <dxl:SortingColumnList>
                <dxl:SortingColumn ColId="23" SortOperatorMdid="0.412.1.0" SortOperatorName="&lt;" SortNullsFirst="false"/>
              </dxl:SortingColumnList>
              <dxl:LimitCount/>
              <dxl:LimitOffset/>
              <dxl:RedistributeMotion InputSegments="0,1" OutputSegments="0,1">
                <dxl:Properties>
                  <dxl:Cost StartupCost="0" TotalCost="2951.636082" Rows="1.000000" Width="8"/>
                </dxl:Properties>
                <dxl:ProjList>
                  <dxl:ProjElem ColId="23" Alias="fivemin">
                    <dxl:Ident ColId="23" ColName="fivemin" TypeMdid="0.20.1.0"/>
                  </dxl:ProjElem>
                </dxl:ProjList>
                <dxl:Filter/>
                <dxl:SortingColumnList/>
                <dxl:HashExprList>
                  <dxl:HashExpr>
                    <dxl:Ident ColId="23" ColName="fivemin" TypeMdid="0.20.1.0"/>
                  </dxl:HashExpr>
                </dxl:HashExprList>
                <dxl:Result>
                  <dxl:Properties>
                    <dxl:Cost StartupCost="0" TotalCost="2951.636066" Rows="1.000000" Width="8"/>
                  </dxl:Properties>
                  <dxl:ProjList>
                    <dxl:ProjElem ColId="23" Alias="fivemin">
                      <dxl:OpExpr OperatorName="*" OperatorMdid="0.690.1.0" OperatorType="0.20.1.0">
                        <dxl:OpExpr OperatorName="/" OperatorMdid="0.691.1.0" OperatorType="0.20.1.0">
                          <dxl:OpExpr OperatorName="/" OperatorMdid="0.691.1.0" OperatorType="0.20.1.0">
                            <dxl:Ident ColId="1" ColName="event_ts" TypeMdid="0.20.1.0"/>
                            <dxl:ConstValue TypeMdid="0.23.1.0" Value="100000"/>
                          </dxl:OpExpr>
                          <dxl:ConstValue TypeMdid="0.23.1.0" Value="5"/>
                        </dxl:OpExpr>
                        <dxl:ConstValue TypeMdid="0.23.1.0" Value="5"/>
                      </dxl:OpExpr>
                    </dxl:ProjElem>
                  </dxl:ProjList>
                  <dxl:Filter/>
                  <dxl:OneTimeFilter/>
                  <dxl:NestedLoopJoin JoinType="Inner" IndexNestedLoopJoin="true" OuterRefAsParam="false">
                    <dxl:Properties>
                      <dxl:Cost StartupCost="0" TotalCost="2951.636062" Rows="1.000000" Width="8"/>
                    </dxl:Properties>
                    <dxl:ProjList>
                      <dxl:ProjElem ColId="1" Alias="event_ts">
                        <dxl:Ident ColId="1" ColName="event_ts" TypeMdid="0.20.1.0"/>
                      </dxl:ProjElem>
                    </dxl:ProjList>
                    <dxl:Filter/>
                    <dxl:JoinFilter>
                      <dxl:ConstValue TypeMdid="0.16.1.0" Value="true"/>
                    </dxl:JoinFilter>
                    <dxl:BroadcastMotion InputSegments="0,1" OutputSegments="0,1">
                      <dxl:Properties>
                        <dxl:Cost StartupCost="0" TotalCost="431.292687" Rows="840.000000" Width="25"/>
                      </dxl:Properties>
                      <dxl:ProjList>
                        <dxl:ProjElem ColId="0" Alias="symbol">
                          <dxl:Ident ColId="0" ColName="symbol" TypeMdid="0.1042.1.0"/>
                        </dxl:ProjElem>
                        <dxl:ProjElem ColId="1" Alias="event_ts">
                          <dxl:Ident ColId="1" ColName="event_ts" TypeMdid="0.20.1.0"/>
                        </dxl:ProjElem>
                      </dxl:ProjList>
                      <dxl:Filter/>
                      <dxl:SortingColumnList/>
                      <dxl:TableScan>
                        <dxl:Properties>
                          <dxl:Cost StartupCost="0" TotalCost="431.008085" Rows="420.000000" Width="25"/>
                        </dxl:Properties>
                        <dxl:ProjList>
                          <dxl:ProjElem ColId="0" Alias="symbol">
                            <dxl:Ident ColId="0" ColName="symbol" TypeMdid="0.1042.1.0"/>
                          </dxl:ProjElem>
                          <dxl:ProjElem ColId="1" Alias="event_ts">
                            <dxl:Ident ColId="1" ColName="event_ts" TypeMdid="0.20.1.0"/>
                          </dxl:ProjElem>
                        </dxl:ProjList>
                        <dxl:Filter/>
                        <dxl:TableDescriptor Mdid="6.16166631.1.1" TableName="my_tt_agg_small">
                          <dxl:Columns>
                            <dxl:Column ColId="0" Attno="1" ColName="symbol" TypeMdid="0.1042.1.0" ColWidth="16"/>
                            <dxl:Column ColId="1" Attno="2" ColName="event_ts" TypeMdid="0.20.1.0"/>
                            <dxl:Column ColId="4" Attno="-1" ColName="ctid" TypeMdid="0.27.1.0"/>
                            <dxl:Column ColId="5" Attno="-3" ColName="xmin" TypeMdid="0.28.1.0"/>
                            <dxl:Column ColId="6" Attno="-4" ColName="cmin" TypeMdid="0.29.1.0"/>
                            <dxl:Column ColId="7" Attno="-5" ColName="xmax" TypeMdid="0.28.1.0"/>
                            <dxl:Column ColId="8" Attno="-6" ColName="cmax" TypeMdid="0.29.1.0"/>
                            <dxl:Column ColId="9" Attno="-7" ColName="tableoid" TypeMdid="0.26.1.0"/>
                            <dxl:Column ColId="10" Attno="-8" ColName="gp_segment_id" TypeMdid="0.23.1.0"/>
                          </dxl:Columns>
                        </dxl:TableDescriptor>
                      </dxl:TableScan>
                    </dxl:BroadcastMotion>
                    <dxl:Sequence>
                      <dxl:Properties>
                        <dxl:Cost StartupCost="0" TotalCost="2520.336966" Rows="1.000000" Width="1"/>
                      </dxl:Properties>
                      <dxl:ProjList>
                        <dxl:ProjElem ColId="11" Alias="ets">
                          <dxl:Ident ColId="11" ColName="ets" TypeMdid="0.20.1.0"/>
                        </dxl:ProjElem>
                        <dxl:ProjElem ColId="12" Alias="sym">
                          <dxl:Ident ColId="12" ColName="sym" TypeMdid="0.1043.1.0"/>
                        </dxl:ProjElem>
                        <dxl:ProjElem ColId="15" Alias="end_ts">
                          <dxl:Ident ColId="15" ColName="end_ts" TypeMdid="0.20.1.0"/>
                        </dxl:ProjElem>
                      </dxl:ProjList>
                      <dxl:PartitionSelector RelationMdid="6.16166659.1.1" PartitionLevels="1" ScanId="1">
                        <dxl:Properties>
                          <dxl:Cost StartupCost="10" TotalCost="100" Rows="100" Width="4"/>
                        </dxl:Properties>
                        <dxl:ProjList/>
                        <dxl:PartEqFilters>
                          <dxl:ConstValue TypeMdid="0.16.1.0" Value="true"/>
                        </dxl:PartEqFilters>
                        <dxl:PartFilters>
                          <dxl:ConstValue TypeMdid="0.16.1.0" Value="true"/>
                        </dxl:PartFilters>
                        <dxl:ResidualFilter>
                          <dxl:ConstValue TypeMdid="0.16.1.0" Value="true"/>
                        </dxl:ResidualFilter>
                        <dxl:PropagationExpression>
                          <dxl:ConstValue TypeMdid="0.23.1.0" Value="1"/>
                        </dxl:PropagationExpression>
                        <dxl:PrintableFilter>
                          <dxl:ConstValue TypeMdid="0.16.1.0" Value="true"/>
                        </dxl:PrintableFilter>
                      </dxl:PartitionSelector>
                      <dxl:DynamicIndexScan IndexScanDirection="Forward" PartIndexId="1">
                        <dxl:Properties>
                          <dxl:Cost StartupCost="0" TotalCost="2520.336966" Rows="1.000000" Width="1"/>
                        </dxl:Properties>
                        <dxl:ProjList>
                          <dxl:ProjElem ColId="11" Alias="ets">
                            <dxl:Ident ColId="11" ColName="ets" TypeMdid="0.20.1.0"/>
                          </dxl:ProjElem>
                          <dxl:ProjElem ColId="12" Alias="sym">
                            <dxl:Ident ColId="12" ColName="sym" TypeMdid="0.1043.1.0"/>
                          </dxl:ProjElem>
                          <dxl:ProjElem ColId="15" Alias="end_ts">
                            <dxl:Ident ColId="15" ColName="end_ts" TypeMdid="0.20.1.0"/>
                          </dxl:ProjElem>
                        </dxl:ProjList>
                        <dxl:Filter>
                          <dxl:And>
                            <dxl:Comparison ComparisonOperator="&lt;=" OperatorMdid="0.414.1.0">
                              <dxl:Ident ColId="11" ColName="ets" TypeMdid="0.20.1.0"/>
                              <dxl:Ident ColId="1" ColName="event_ts" TypeMdid="0.20.1.0"/>
                            </dxl:Comparison>
                            <dxl:Comparison ComparisonOperator="&gt;" OperatorMdid="0.413.1.0">
                              <dxl:Ident ColId="15" ColName="end_ts" TypeMdid="0.20.1.0"/>
                              <dxl:Ident ColId="1" ColName="event_ts" TypeMdid="0.20.1.0"/>
                            </dxl:Comparison>
                            <dxl:Comparison ComparisonOperator="=" OperatorMdid="0.1054.1.0">
                              <dxl:Cast TypeMdid="0.1042.1.0" FuncId="0.0.0.0">
                                <dxl:Ident ColId="12" ColName="sym" TypeMdid="0.1043.1.0"/>
                              </dxl:Cast>
                              <dxl:Ident ColId="0" ColName="symbol" TypeMdid="0.1042.1.0"/>
                            </dxl:Comparison>
                          </dxl:And>
                        </dxl:Filter>
                        <dxl:IndexCondList>
                          <dxl:Comparison ComparisonOperator="&lt;=" OperatorMdid="0.414.1.0">
                            <dxl:Ident ColId="11" ColName="ets" TypeMdid="0.20.1.0"/>
                            <dxl:Ident ColId="1" ColName="event_ts" TypeMdid="0.20.1.0"/>
                          </dxl:Comparison>
                          <dxl:Comparison ComparisonOperator="&gt;" OperatorMdid="0.413.1.0">
                            <dxl:Ident ColId="15" ColName="end_ts" TypeMdid="0.20.1.0"/>
                            <dxl:Ident ColId="1" ColName="event_ts" TypeMdid="0.20.1.0"/>
                          </dxl:Comparison>
                        </dxl:IndexCondList>
                        <dxl:IndexDescriptor Mdid="0.16166830.1.0" IndexName="my_tq_agg_small_ets_end_ts_ix_1_prt_p1"/>
                        <dxl:TableDescriptor Mdid="6.16166659.1.1" TableName="my_tq_agg_small">
                          <dxl:Columns>
                            <dxl:Column ColId="11" Attno="1" ColName="ets" TypeMdid="0.20.1.0"/>
                            <dxl:Column ColId="12" Attno="2" ColName="sym" TypeMdid="0.1043.1.0" ColWidth="16"/>
                            <dxl:Column ColId="13" Attno="3" ColName="bid_price" TypeMdid="0.1700.1.0"/>
                            <dxl:Column ColId="15" Attno="5" ColName="end_ts" TypeMdid="0.20.1.0"/>
                            <dxl:Column ColId="16" Attno="-1" ColName="ctid" TypeMdid="0.27.1.0"/>
                            <dxl:Column ColId="17" Attno="-3" ColName="xmin" TypeMdid="0.28.1.0"/>
                            <dxl:Column ColId="18" Attno="-4" ColName="cmin" TypeMdid="0.29.1.0"/>
                            <dxl:Column ColId="19" Attno="-5" ColName="xmax" TypeMdid="0.28.1.0"/>
                            <dxl:Column ColId="20" Attno="-6" ColName="cmax" TypeMdid="0.29.1.0"/>
                            <dxl:Column ColId="21" Attno="-7" ColName="tableoid" TypeMdid="0.26.1.0"/>
                            <dxl:Column ColId="22" Attno="-8" ColName="gp_segment_id" TypeMdid="0.23.1.0"/>
                          </dxl:Columns>
                        </dxl:TableDescriptor>
                      </dxl:DynamicIndexScan>
                    </dxl:Sequence>
                  </dxl:NestedLoopJoin>
                </dxl:Result>
              </dxl:RedistributeMotion>
            </dxl:Sort>
          </dxl:Aggregate>
        </dxl:Sort>
      </dxl:GatherMotion>
    </dxl:Plan>
  </dxl:Thread>
</dxl:DXLMessage>
